<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_attribute`;");
E_C("CREATE TABLE `ecs_attribute` (
  `attr_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `attr_name` varchar(60) NOT NULL DEFAULT '',
  `attr_input_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `attr_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `attr_values` text NOT NULL,
  `attr_index` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_linked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `attr_group` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_attr_gallery` tinyint(1) unsigned NOT NULL,
  `attr_txm` tinyint(1) NOT NULL DEFAULT '0' COMMENT '判断条形码是否显示',
  PRIMARY KEY (`attr_id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_attribute` values('17','3','类型','1','0','单鞋\r\n板鞋\r\n增高鞋\r\n厚底鞋\r\n帆布鞋\r\n低筒靴\r\n摇摇鞋','0','0','0','0','0','0');");
E_D("replace into `ecs_attribute` values('18','3','风格','1','0','休闲\r\n甜美\r\n欧美\r\n韩版\r\n简约\r\n英伦\r\n学院\r\n通勤\r\n日系','0','0','0','0','0','0');");
E_D("replace into `ecs_attribute` values('4','1','颜色','1','1','白色\r\n黑色\r\n灰色\r\n金色\r\n银色\r\n红色\r\n蓝色\r\n粉色\r\n黄色\r\n绿色','0','0','1','0','1','0');");
E_D("replace into `ecs_attribute` values('5','1','屏幕尺寸','1','1','5.6英寸及以上\r\n5.5-5.0英寸\r\n4.9-4.1英寸\r\n4.0-3.1英寸\r\n3.0英寸及以下','0','0','1','0','0','0');");
E_D("replace into `ecs_attribute` values('6','2','颜色','1','1','白色\r\n蓝色\r\n粉色\r\n黑色\r\n水绿色\r\n裸色\r\n黄色','0','0','1','0','1','1');");
E_D("replace into `ecs_attribute` values('7','2','图案','1','0','纯色\r\n条纹\r\n字母\r\n碎花\r\n卡通\r\n人物\r\n格子\r\n拼接\r\n几何\r\n动物\r\n花卉\r\n3D印花','0','0','1','0','0','0');");
E_D("replace into `ecs_attribute` values('8','2','流行元素','1','0','条纹\r\n简约\r\n纯色\r\n刺绣\r\n印花\r\n平纹\r\n拼接色\r\n复古\r\n拼接\r\n纱网\r\n绣花\r\n蕾丝','0','0','0','0','0','0');");
E_D("replace into `ecs_attribute` values('9','2','版型','1','0','修身型\r\n收腰型\r\n标准型（腰围=胸围）\r\n宽松型\r\n宽松型（腰围>胸围）','0','0','0','0','0','0');");
E_D("replace into `ecs_attribute` values('10','2','主要材质','1','0','莫代尔\r\n棉\r\n涤纶\r\n麻','0','0','0','0','0','0');");
E_D("replace into `ecs_attribute` values('16','1','大家说','1','0','屏幕大\r\n待机时间长\r\n电池耐用\r\n反应快\r\n外观不错\r\n系统流畅\r\n后盖很漂亮','0','0','0','0','0','0');");
E_D("replace into `ecs_attribute` values('15','1','系统','1','0','安卓（Android）\r\n微软（WindowsPhone）\r\n苹果（IOS）\r\n其它','0','0','0','0','0','0');");
E_D("replace into `ecs_attribute` values('13','3','尺码','1','1','7\r\n7.5\r\n8\r\n8.5\r\n9\r\n9.5\r\n10\r\n10.5\r\n11\r\n12\r\n19.5\r\n21','0','0','0','0','0','0');");
E_D("replace into `ecs_attribute` values('14','3','颜色','1','1','灰色\r\n黑色\r\n白色\r\n蓝色\r\n水绿色\r\n红色\r\n枚红色\r\n棕色\r\n裸色','0','0','0','0','1','0');");
E_D("replace into `ecs_attribute` values('19','2','尺寸','1','1','12\r\n15\r\n20','0','0','0','0','0','1');");

require("../../inc/footer.php");
?>